<Page id="1" templateExtension="html" relativePath="..\.." fullRelativePath=".\gharardad\user_part" secured="False" urlType="Relative" isIncluded="False" SSLAccess="False" wizardTheme="Cobalt" wizardThemeType="File" needGeneration="0">
	<Components>
		<Grid id="2" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="1" connection="projectkar" dataSource="SELECT CONTRACT.*, PROJECT.NAME AS PROJECT_NAME,SITUATIONS_DEF_SC.&quot;DESC&quot; SITUATION_DESC
FROM CONTRACT,
PROJECT,
CONTRACT_SITUATION,
SITUATIONS_DEF_SC
WHERE ( 
     (CONTRACT.PRO_ID = PROJECT.ID) 
 AND (CONTRACT_SITUATION.CONTRACT_ID = CONTRACT.ID) 
 AND CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
 AND (SITUATIONS_DEF_SC.CODE = CONTRACT_SITUATION.SITUATION)  
 AND (CONTRACT.ID={CONTRACT_ID})                           
 AND PROJECT.USE_ID={CUSTOMER_ID}
);" name="CONTRACT_PROJECT_CONTRACT" pageSizeLimit="100" wizardCaption="List of CONTRACT, PROJECT, CONTRACT SITUATION, SITUATIONS DEF SC " wizardTheme="Cobalt" wizardThemeType="File" wizardGridType="Justified" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Label id="49" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="CONTRACT_NAME" fieldSource="NAME" wizardCaption="CONTRACT NAME" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="50" wizardMaxLength="80" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="50" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="DATE_OF_CREATION" fieldSource="DATE_OF_CREATION" wizardCaption="DATE OF CREATION" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="51" fieldSourceType="DBColumn" dataType="Float" html="False" editable="False" name="MONEY" fieldSource="MONEY" wizardCaption="MONEY" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="12" wizardMaxLength="12" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="52" fieldSourceType="DBColumn" dataType="Date" html="False" editable="False" name="EXPIRATION" fieldSource="EXPIRATION" wizardCaption="EXPIRATION" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="10" wizardMaxLength="26" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="53" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="PROJECT_NAME" fieldSource="PROJECT_NAME" wizardCaption="PROJECT NAME" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="20" wizardMaxLength="20" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
				<Label id="54" fieldSourceType="DBColumn" dataType="Text" html="False" editable="False" name="SITUATION_DESC" fieldSource="SITUATION_DESC" wizardCaption="TEXT" wizardTheme="Cobalt" wizardThemeType="File" wizardSize="50" wizardMaxLength="100" wizardIsPassword="False" wizardUseTemplateBlock="False">
					<Components/>
					<Events/>
				</Label>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables>
				<JoinTable id="36" tableName="CONTRACT" posWidth="149" posHeight="216" posLeft="66" posTop="50"/>
				<JoinTable id="41" tableName="PROJECT" posWidth="155" posHeight="120" posLeft="289" posTop="211"/>
				<JoinTable id="43" tableName="CONTRACT_SITUATION" posWidth="126" posHeight="168" posLeft="267" posTop="10"/>
				<JoinTable id="44" tableName="SITUATIONS_DEF_SC" posWidth="100" posHeight="138" posLeft="430" posTop="24"/>
			</JoinTables>
			<JoinLinks>
				<JoinTable2 id="46" fieldLeft="CONTRACT.PRO_ID" fieldRight="PROJECT.ID" tableLeft="CONTRACT" tableRight="PROJECT" conditionType="Equal" joinType="inner"/>
				<JoinTable2 id="47" fieldLeft="CONTRACT_SITUATION.CONTRACT_ID" fieldRight="CONTRACT.ID" tableLeft="CONTRACT_SITUATION" tableRight="CONTRACT" conditionType="Equal" joinType="inner"/>
				<JoinTable2 id="48" fieldLeft="SITUATIONS_DEF_SC.CODE" fieldRight="CONTRACT_SITUATION.SITUATION" tableLeft="SITUATIONS_DEF_SC" tableRight="CONTRACT_SITUATION" joinType="inner"/>
			</JoinLinks>
			<Fields>
				<Field id="37" tableName="CONTRACT" alias="CONTRACT_NAME" fieldName="CONTRACT.NAME"/>
				<Field id="38" tableName="CONTRACT" fieldName="DATE_OF_CREATION"/>
				<Field id="39" tableName="CONTRACT" fieldName="MONEY"/>
				<Field id="40" tableName="CONTRACT" fieldName="EXPIRATION"/>
				<Field id="42" tableName="PROJECT" alias="PROJECT_NAME" fieldName="PROJECT.NAME"/>
				<Field id="45" tableName="SITUATIONS_DEF_SC" fieldName="TEXT"/>
			</Fields>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="55" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
				<SQLParameter id="67" variable="CONTRACT_ID" parameterType="URL" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="CONTRACT_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
		<Grid id="56" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="1" connection="projectkar" name="if_contract_befor_term" dataSource="SELECT CONTRACT.*
FROM CONTRACT,
PROJECT,
CONTRACT_SITUATION,
SITUATIONS_DEF_SC
WHERE ( 
     (CONTRACT.PRO_ID = PROJECT.ID) 
 AND (CONTRACT_SITUATION.CONTRACT_ID = CONTRACT.ID) 
 AND CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
 AND (SITUATIONS_DEF_SC.CODE = CONTRACT_SITUATION.SITUATION)               
 AND PROJECT.USE_ID={CUSTOMER_ID}
 AND (CONTRACT.ID={CONTRACT_ID})                           
 AND SITUATIONS_DEF_SC.TEXT='BEFORE_TERMINATION'
);" pageSizeLimit="100" wizardCaption="List of CONTRACT " wizardTheme="Cobalt" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Link id="59" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="terminate_ok" wizardTheme="Cobalt" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters>
						<LinkParameter id="61" sourceType="DataField" name="CONTRACT_ID" source="ID"/>
					</LinkParameters>
				</Link>
				<Link id="60" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="terminate_reject" wizardTheme="Cobalt" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters>
						<LinkParameter id="62" sourceType="DataField" name="CONTRACT_ID" source="ID"/>
					</LinkParameters>
				</Link>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables/>
			<JoinLinks/>
			<Fields/>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="58" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
				<SQLParameter id="68" variable="CONTRACT_ID" parameterType="URL" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="CONTRACT_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
		<Grid id="63" secured="False" sourceType="SQL" returnValueType="Number" defaultPageSize="1" name="if_contract_on_rebuild" connection="projectkar" dataSource="SELECT CONTRACT.*
FROM CONTRACT,
PROJECT,
CONTRACT_SITUATION,
SITUATIONS_DEF_SC
WHERE ( 
     (CONTRACT.PRO_ID = PROJECT.ID) 
 AND (CONTRACT_SITUATION.CONTRACT_ID = CONTRACT.ID) 
 AND CONTRACT_SITUATION.ID=
             (SELECT max(CONTRACT_SITUATION.ID)
              FROM CONTRACT_SITUATION 
              where CONTRACT_SITUATION.CONTRACT_ID=CONTRACT.ID)
 AND (SITUATIONS_DEF_SC.CODE = CONTRACT_SITUATION.SITUATION)               
 AND PROJECT.USE_ID={CUSTOMER_ID}
 AND (CONTRACT.ID={CONTRACT_ID})                           
 AND SITUATIONS_DEF_SC.TEXT='ON_REBUILD_SITUATION'
);" pageSizeLimit="100" wizardCaption="List of CONTRACT " wizardTheme="Cobalt" wizardThemeType="File" wizardGridType="Tabular" wizardAllowInsert="False" wizardAltRecord="False" wizardRecordSeparator="False" parameterTypeListName="ParameterTypeList" activeCollection="SQLParameters">
			<Components>
				<Link id="64" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="rebuild_accept" wizardTheme="Cobalt" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters/>
				</Link>
				<Link id="65" fieldSourceType="DBColumn" dataType="Text" html="False" hrefType="Page" urlType="Relative" preserveParameters="GET" editable="False" name="rebuild_reject" wizardTheme="Cobalt" wizardThemeType="File">
					<Components/>
					<Events/>
					<LinkParameters/>
				</Link>
			</Components>
			<Events/>
			<TableParameters/>
			<JoinTables/>
			<JoinLinks/>
			<Fields/>
			<SPParameters/>
			<SQLParameters>
				<SQLParameter id="66" variable="CUSTOMER_ID" parameterType="Session" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="USER_ID"/>
				<SQLParameter id="69" variable="CONTRACT_ID" parameterType="URL" defaultValue="-1" dataType="Integer" format="0;(0)" parameterSource="CONTRACT_ID"/>
			</SQLParameters>
			<SecurityGroups/>
		</Grid>
	</Components>
	<CodeFiles>
		<CodeFile id="Model" language="JSP" name="see_contract_status_detail.xml" path="." comment="&lt;!--" commentEnd="--&gt;" codePage="iso-8859-1" forShow="False"/>
		<CodeFile id="JSP" language="JSP" name="see_contract_status_detail.jsp" path="." comment="&lt;%--" commentEnd="--%&gt;" codePage="iso-8859-1" forShow="True" url="see_contract_status_detail.jsp"/>
		<CodeFile id="Handlers" language="JSP" name="see_contract_status_detailHandlers.jsp" path="." comment="//" codePage="iso-8859-1" forShow="False"/>
	</CodeFiles>
	<SecurityGroups/>
	<Events/>
</Page>
